package com.zyd.shiro.utils;

import com.zyd.shiro.business.annotation.FieldValue;
import com.zyd.shiro.business.enums.PurWay;
import com.zyd.shiro.framework.object.AbstractDataDO;
import com.zyd.shiro.persistence.beans.*;
import com.zyd.shiro.persistence.mapper.PakLocationMapper;
import com.zyd.shiro.persistence.mapper.PakPurchaseMapper;
import com.zyd.shiro.persistence.mapper.SysDeptMapper;
import com.zyd.shiro.persistence.mapper.SysOrgMapper;
import com.zyd.shiro.util.ResultUtil;
import lombok.Data;
import lombok.SneakyThrows;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.formula.functions.T;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import javax.annotation.Resource;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.lang.reflect.Field;
import java.lang.reflect.InvocationTargetException;
import java.lang.reflect.Method;
import java.lang.reflect.Type;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.*;

@Data
public class Test {
    @Resource
    private SysOrgMapper sysOrgMapper;

    @Resource
    private SysDeptMapper sysDeptMapper;

    @Resource
    private PakLocationMapper pakLocationMapper;

    @Resource
    private PakPurchaseMapper pakPurchaseMapper;

    @SneakyThrows
    public static void main(String[] args) {
        File file = new File("D://mode.xlsx");

        ExcelUtil<PakPurchaseLine> excelUtil = new ExcelUtil<>();
        List<PakPurchaseLine> acfForms = excelUtil.listFromData(file,PakPurchaseLine.class);
        for (PakPurchaseLine a : acfForms) {
            System.out.println(a);
        }







    }


}


